﻿CREATE VIEW [dbo].[vwUsersByCustomer]
AS
SELECT     dbo.CustomerUser.CustomerID, dbo.Users.UserName, dbo.Users.Password
FROM         dbo.CustomerUser INNER JOIN
                      dbo.Users ON dbo.CustomerUser.UserID = dbo.Users.UserID;

